Sort

Use this box if you’re sorting by more than one column or row. After the range is sorted by the column or row in the Sort By box, the range is sorted by additional columns or rows in sequence.

Click Ascending to sort the lowest number, the beginning of the alphabet, or the earliest date first in the sorted range. Click Descending to sort the highest number, the end of the alphabet, or the latest date first in the sorted range. Blank cells are always sorted last.

Click Header row to exclude the first row from the sort if your list has column labels in the uppermost row. Click No header row to include the first row in the sort if the list doesn't have column labels in the uppermost row.

Lets you specify a custom sort order, such as Low, Medium, High or Jan, Feb, Mar, and so forth, for the column selected in the Sort by box. You can also specify a case-sensitive sort and sort either from top to bottom or from left to right. Click to open the Sort Options dialog box.

First key sort order

Select the custom sort order you want.

Case sensitive

Click Case sensitive to sort on capitalization. This option is not available when you sort items in a PivotTable report.

Orientation

Click Sort top to bottom to sort rows by the values in one or more columns. In PivotTable reports, you can sort by only one column. Click Sort left to right to sort columns by the values in one or more rows. In PivotTable reports, you can sort by only one row.